Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	152534
Missing cells	506
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	16.3 MiB
Average record size in memory	112.0 B

Variable types

Numeric	10
Categorical	2
Boolean	2

Warnings

`Volume_7days` is highly correlated with `Volume_15days`	High correlation
`Volume_15days` is highly correlated with `Volume_7days` and 1 other fields	High correlation
`Volume_Monthly` is highly correlated with `Volume_15days`	High correlation
`%NFCR` is highly correlated with `Target`	High correlation
`Target` is highly correlated with `%NFCR`	High correlation
`Volume_7days` is highly correlated with `Volume_15days`	High correlation
`Volume_15days` is highly correlated with `Volume_7days`	High correlation
`Volume_Monthly` is highly correlated with `Target`	High correlation
`Tempo_Medio_Chat` is highly correlated with `Tempo_Medio_Email` and 1 other fields	High correlation
`Tempo_Medio_Email` is highly correlated with `Tempo_Medio_Chat` and 1 other fields	High correlation
`AWT_Chat` is highly correlated with `Tempo_Medio_Chat` and 1 other fields	High correlation
`%NFCR` is highly correlated with `Target`	High correlation
`Target` is highly correlated with `Volume_Monthly` and 1 other fields	High correlation
`Volume_7days` is highly correlated with `Volume_15days`	High correlation
`Volume_15days` is highly correlated with `Volume_7days`	High correlation
`Volume_Monthly` is highly correlated with `Target`	High correlation
`Tempo_Medio_Chat` is highly correlated with `Tempo_Medio_Email` and 1 other fields	High correlation
`Tempo_Medio_Email` is highly correlated with `Tempo_Medio_Chat` and 1 other fields	High correlation
`AWT_Chat` is highly correlated with `Tempo_Medio_Chat` and 1 other fields	High correlation
`%NFCR` is highly correlated with `Target`	High correlation
`Target` is highly correlated with `Volume_Monthly` and 1 other fields	High correlation
`%Insatisfação(CSAT)` is highly correlated with `CSAT_Rated`	High correlation
`%NFCR` is highly correlated with `Target`	High correlation
`Volume_15days` is highly correlated with `Volume_7days` and 1 other fields	High correlation
`Target` is highly correlated with `%NFCR`	High correlation
`Volume_7days` is highly correlated with `Volume_15days` and 1 other fields	High correlation
`CSAT_Rated` is highly correlated with `%Insatisfação(CSAT)`	High correlation
`Volume_Monthly` is highly correlated with `Volume_15days` and 1 other fields	High correlation
`Volume_Monthly` is highly skewed (γ1 = 23.0229645)	Skewed
`Volume_7days` has 99728 (65.4%) zeros	Zeros
`Volume_15days` has 53598 (35.1%) zeros	Zeros
`Tempo_Medio_Chat` has 57429 (37.6%) zeros	Zeros
`Tempo_Medio_Email` has 86952 (57.0%) zeros	Zeros
`AWT_Chat` has 57075 (37.4%) zeros	Zeros
`%NFCR` has 117210 (76.8%) zeros	Zeros
`%Insatisfação(CSAT)` has 147322 (96.6%) zeros	Zeros
`CSAT_Rated` has 105973 (69.5%) zeros	Zeros

Reproduction

Analysis started	2021-06-15 18:21:57.238496
Analysis finished	2021-06-15 18:22:40.759397
Duration	43.52 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Requester_ID
Real number (ℝ_≥0)

Distinct	128761
Distinct (%)	84.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9755498.253

Minimum	37
Maximum	19086022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	37
5-th percentile	847868.85
Q1	5357028.5
median	9530719.5
Q3	14923859
95-th percentile	18494161
Maximum	19086022
Range	19085985
Interquartile range (IQR)	9566830.5

Descriptive statistics

Standard deviation	5580892.875
Coefficient of variation (CV)	0.5720766618
Kurtosis	-1.221461731
Mean	9755498.253
Median Absolute Deviation (MAD)	4790297.5
Skewness	-0.05654703246
Sum	1.488045171 × 10¹²
Variance	3.114636528 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6865722	4	< 0.1%
10608424	4	< 0.1%
16967303	4	< 0.1%
11900595	4	< 0.1%
13719087	4	< 0.1%
11310838	4	< 0.1%
2259256	4	< 0.1%
16813514	4	< 0.1%
14082671	4	< 0.1%
9301547	4	< 0.1%
Other values (128751)	152494	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
37	2	< 0.1%
85	1	< 0.1%
111	1	< 0.1%
220	1	< 0.1%
285	1	< 0.1%
394	2	< 0.1%
612	2	< 0.1%
664	1	< 0.1%
759	1	< 0.1%
826	1	< 0.1%

Value	Count	Frequency (%)
19086022	2	< 0.1%
19084058	1	< 0.1%
19080777	1	< 0.1%
19080729	1	< 0.1%
19080702	1	< 0.1%
19080647	1	< 0.1%
19076745	1	< 0.1%
19075673	1	< 0.1%
19075314	2	< 0.1%
19075187	1	< 0.1%

Month
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

2021_02	47783
2021_05	43850
2021_01	31919
2021_04	28982

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1067738
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021_01
2nd row	2021_01
3rd row	2021_01
4th row	2021_01
5th row	2021_01

Common Values

Value	Count	Frequency (%)
2021_02	47783	31.3%
2021_05	43850	28.7%
2021_01	31919	20.9%
2021_04	28982	19.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2021_02	47783	31.3%
2021_05	43850	28.7%
2021_01	31919	20.9%
2021_04	28982	19.0%

Most occurring characters

Value	Count	Frequency (%)
2	352851	33.0%
0	305068	28.6%
1	184453	17.3%
_	152534	14.3%
5	43850	4.1%
4	28982	2.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	915204	85.7%
Connector Punctuation	152534	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	352851	38.6%
0	305068	33.3%
1	184453	20.2%
5	43850	4.8%
4	28982	3.2%

Connector Punctuation

Value	Count	Frequency (%)
_	152534	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1067738	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	352851	33.0%
0	305068	28.6%
1	184453	17.3%
_	152534	14.3%
5	43850	4.1%
4	28982	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1067738	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	352851	33.0%
0	305068	28.6%
1	184453	17.3%
_	152534	14.3%
5	43850	4.1%
4	28982	2.7%

Volume_7days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4351816644

Minimum	0
Maximum	43
Zeros	99728
Zeros (%)	65.4%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	43
Range	43
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7234225162
Coefficient of variation (CV)	1.662346039
Kurtosis	137.5918115
Mean	0.4351816644
Median Absolute Deviation (MAD)	0
Skewness	4.667368484
Sum	66380
Variance	0.523340137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	99728	65.4%
1	43016	28.2%
2	7315	4.8%
3	1717	1.1%
4	496	0.3%
5	156	0.1%
6	67	< 0.1%
7	14	< 0.1%
8	12	< 0.1%
9	4	< 0.1%
Other values (8)	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	99728	65.4%
1	43016	28.2%
2	7315	4.8%
3	1717	1.1%
4	496	0.3%
5	156	0.1%
6	67	< 0.1%
7	14	< 0.1%
8	12	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
43	1	< 0.1%
36	1	< 0.1%
22	1	< 0.1%
21	1	< 0.1%
18	1	< 0.1%
14	1	< 0.1%
13	1	< 0.1%
10	2	< 0.1%
9	4	< 0.1%
8	12	< 0.1%

Volume_15days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8544193426

Minimum	0
Maximum	83
Zeros	53598
Zeros (%)	35.1%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	2
Maximum	83
Range	83
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9083294299
Coefficient of variation (CV)	1.063095584
Kurtosis	506.5507973
Mean	0.8544193426
Median Absolute Deviation (MAD)	0
Skewness	8.050614037
Sum	130328
Variance	0.8250623532
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
1	77608	50.9%
0	53598	35.1%
2	15150	9.9%
3	4057	2.7%
4	1275	0.8%
5	470	0.3%
6	204	0.1%
7	79	0.1%
8	43	< 0.1%
9	18	< 0.1%
Other values (12)	32	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	53598	35.1%
1	77608	50.9%
2	15150	9.9%
3	4057	2.7%
4	1275	0.8%
5	470	0.3%
6	204	0.1%
7	79	0.1%
8	43	< 0.1%
9	18	< 0.1%

Value	Count	Frequency (%)
83	1	< 0.1%
43	1	< 0.1%
41	1	< 0.1%
22	1	< 0.1%
21	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
13	2	< 0.1%
12	2	< 0.1%

Volume_Monthly
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.369255379

Minimum	0
Maximum	123
Zeros	58
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	123
Range	123
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9331045571
Coefficient of variation (CV)	0.6814686079
Kurtosis	2303.634694
Mean	1.369255379
Median Absolute Deviation (MAD)	0
Skewness	23.0229645
Sum	208858
Variance	0.8706841144
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	115770	75.9%
2	25301	16.6%
3	7177	4.7%
4	2415	1.6%
5	921	0.6%
6	450	0.3%
7	197	0.1%
8	112	0.1%
0	58	< 0.1%
9	46	< 0.1%
Other values (14)	87	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58	< 0.1%
1	115770	75.9%
2	25301	16.6%
3	7177	4.7%
4	2415	1.6%
5	921	0.6%
6	450	0.3%
7	197	0.1%
8	112	0.1%
9	46	< 0.1%

Value	Count	Frequency (%)
123	1	< 0.1%
73	1	< 0.1%
66	1	< 0.1%
35	1	< 0.1%
21	1	< 0.1%
20	2	< 0.1%
19	4	< 0.1%
18	1	< 0.1%
16	1	< 0.1%
14	7	< 0.1%

ReclameAqui
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	149.1 KiB

False	152131
True	403

Common Values
Chart

Value	Count	Frequency (%)
False	152131	99.7%
True	403	0.3%

SocialMedia
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	149.1 KiB

False	152267
True	267

Common Values
Chart

Value	Count	Frequency (%)
False	152267	99.8%
True	267	0.2%

Tempo_Medio_Chat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	93722
Distinct (%)	61.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	727.1248672

Minimum	0
Maximum	12454.309
Zeros	57429
Zeros (%)	37.6%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	575.604
Q3	1148.8005
95-th percentile	2278.01705
Maximum	12454.309
Range	12454.309
Interquartile range (IQR)	1148.8005

Descriptive statistics

Standard deviation	827.4414861
Coefficient of variation (CV)	1.1379634
Kurtosis	5.469969156
Mean	727.1248672
Median Absolute Deviation (MAD)	575.604
Skewness	1.690214618
Sum	110911264.5
Variance	684659.4129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57429	37.6%
450.997	3	< 0.1%
1504.516	3	< 0.1%
2348.492	3	< 0.1%
848.1489999	3	< 0.1%
790.3280001	3	< 0.1%
573.2390001	3	< 0.1%
490.7820001	3	< 0.1%
685.059	3	< 0.1%
650.141	3	< 0.1%
Other values (93712)	95078	62.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	57429	37.6%
4.114000082	1	< 0.1%
4.426999807	1	< 0.1%
7.703000069	1	< 0.1%
8.33100009	1	< 0.1%
8.451999903	1	< 0.1%
8.624000072	1	< 0.1%
8.818000078	1	< 0.1%
8.90199995	1	< 0.1%
9.210999966	1	< 0.1%

Value	Count	Frequency (%)
12454.309	1	< 0.1%
11140.842	1	< 0.1%
10618.699	1	< 0.1%
10169.427	1	< 0.1%
9502.583	1	< 0.1%
9328.758	1	< 0.1%
9049.861	1	< 0.1%
8783.742	1	< 0.1%
8768.081	1	< 0.1%
8716.933	1	< 0.1%

Tempo_Medio_Email
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	65071
Distinct (%)	42.8%
Missing	506
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	4527.370896

Minimum	0
Maximum	352818.3333
Zeros	86952
Zeros (%)	57.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6497.21875
95-th percentile	19677.13958
Maximum	352818.3333
Range	352818.3333
Interquartile range (IQR)	6497.21875

Descriptive statistics

Standard deviation	9511.600142
Coefficient of variation (CV)	2.100910299
Kurtosis	157.5505026
Mean	4527.370896
Median Absolute Deviation (MAD)	0
Skewness	8.339119467
Sum	688287142.6
Variance	90470537.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	86952	57.0%
12917.70833	2	< 0.1%
9012.833333	2	< 0.1%
3694.333333	2	< 0.1%
2540.583333	2	< 0.1%
21688.58333	2	< 0.1%
8097.041667	2	< 0.1%
8110.666667	1	< 0.1%
7511.375	1	< 0.1%
6579.583333	1	< 0.1%
Other values (65061)	65061	42.7%
(Missing)	506	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	86952	57.0%
12.83333333	1	< 0.1%
16.33333332	1	< 0.1%
20.04166668	1	< 0.1%
27.58333334	1	< 0.1%
29.33333334	1	< 0.1%
30	1	< 0.1%
34.54166666	1	< 0.1%
38.79166666	1	< 0.1%
58.29166666	1	< 0.1%

Value	Count	Frequency (%)
352818.3333	1	< 0.1%
317561.6667	1	< 0.1%
314201.75	1	< 0.1%
306671.25	1	< 0.1%
297123.8333	1	< 0.1%
281697.875	1	< 0.1%
278101.7083	1	< 0.1%
276913.5	1	< 0.1%
276580.4167	1	< 0.1%
271761.0417	1	< 0.1%

AWT_Chat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	5475
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.00344762

Minimum	0
Maximum	3964.471
Zeros	57075
Zeros (%)	37.4%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10
Q3	31.5
95-th percentile	407
Maximum	3964.471
Range	3964.471
Interquartile range (IQR)	31.5

Descriptive statistics

Standard deviation	227.0716534
Coefficient of variation (CV)	3.110423696
Kurtosis	37.72168388
Mean	73.00344762
Median Absolute Deviation (MAD)	10
Skewness	5.537384326
Sum	11135507.88
Variance	51561.53578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57075	37.4%
8	3960	2.6%
9	3914	2.6%
10	3440	2.3%
7	3424	2.2%
11	3052	2.0%
12	2833	1.9%
13	2408	1.6%
6	2384	1.6%
14	2107	1.4%
Other values (5465)	67937	44.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	57075	37.4%
0.4170000553	1	< 0.1%
2	3	< 0.1%
2.277999878	1	< 0.1%
3	29	< 0.1%
3.101000071	1	< 0.1%
3.414999962	1	< 0.1%
3.866333326	1	< 0.1%
4	376	0.2%
4.013000011	1	< 0.1%

Value	Count	Frequency (%)
3964.471	1	< 0.1%
3799.108	1	< 0.1%
3429	1	< 0.1%
3326	1	< 0.1%
3323	1	< 0.1%
3312	1	< 0.1%
3255	1	< 0.1%
3205	1	< 0.1%
3196	1	< 0.1%
3173	1	< 0.1%

%NFCR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.160587886

Minimum	0
Maximum	1
Zeros	117210
Zeros (%)	76.8%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3194564512
Coefficient of variation (CV)	1.989293584
Kurtosis	1.757543736
Mean	0.160587886
Median Absolute Deviation (MAD)	0
Skewness	1.794806351
Sum	24495.1126
Variance	0.1020524242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	117210	76.8%
1	14142	9.3%
0.5	12790	8.4%
0.3333333333	3472	2.3%
0.6666666667	2201	1.4%
0.25	814	0.5%
0.75	511	0.3%
0.6	327	0.2%
0.4	309	0.2%
0.2	154	0.1%
Other values (39)	604	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	117210	76.8%
0.125	1	< 0.1%
0.1428571429	7	< 0.1%
0.1666666667	28	< 0.1%
0.2	154	0.1%
0.25	814	0.5%
0.2857142857	23	< 0.1%
0.3333333333	3472	2.3%
0.375	12	< 0.1%
0.4	309	0.2%

Value	Count	Frequency (%)
1	14142	9.3%
0.9285714286	1	< 0.1%
0.9230769231	1	< 0.1%
0.9166666667	1	< 0.1%
0.9090909091	3	< 0.1%
0.9	5	< 0.1%
0.8888888889	3	< 0.1%
0.875	12	< 0.1%
0.8571428571	33	< 0.1%
0.8421052632	1	< 0.1%

%Insatisfação(CSAT)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03116082524

Minimum	0
Maximum	1
Zeros	147322
Zeros (%)	96.6%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1697143173
Coefficient of variation (CV)	5.446399959
Kurtosis	27.521689
Mean	0.03116082524
Median Absolute Deviation (MAD)	0
Skewness	5.397595305
Sum	4753.085317
Variance	0.02880294951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	147322	96.6%
1	4335	2.8%
0.5	665	0.4%
0.3333333333	120	0.1%
0.6666666667	47	< 0.1%
0.25	20	< 0.1%
0.2	7	< 0.1%
0.4	6	< 0.1%
0.8	2	< 0.1%
0.1428571429	2	< 0.1%
Other values (7)	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	147322	96.6%
0.1111111111	1	< 0.1%
0.125	1	< 0.1%
0.1428571429	2	< 0.1%
0.1666666667	1	< 0.1%
0.2	7	< 0.1%
0.25	20	< 0.1%
0.2857142857	1	< 0.1%
0.3333333333	120	0.1%
0.4	6	< 0.1%

Value	Count	Frequency (%)
1	4335	2.8%
0.8	2	< 0.1%
0.7777777778	1	< 0.1%
0.75	2	< 0.1%
0.6666666667	47	< 0.1%
0.6	1	< 0.1%
0.5	665	0.4%
0.4	6	< 0.1%
0.3333333333	120	0.1%
0.2857142857	1	< 0.1%

CSAT_Rated
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.341137058

Minimum	0
Maximum	10
Zeros	105973
Zeros (%)	69.5%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5624506892
Coefficient of variation (CV)	1.648752828
Kurtosis	7.601910132
Mean	0.341137058
Median Absolute Deviation (MAD)	0
Skewness	1.938748744
Sum	52035
Variance	0.3163507778
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	105973	69.5%
1	42117	27.6%
2	3694	2.4%
3	577	0.4%
4	117	0.1%
5	32	< 0.1%
7	9	< 0.1%
6	8	< 0.1%
8	4	< 0.1%
9	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	105973	69.5%
1	42117	27.6%
2	3694	2.4%
3	577	0.4%
4	117	0.1%
5	32	< 0.1%
6	8	< 0.1%
7	9	< 0.1%
8	4	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9	2	< 0.1%
8	4	< 0.1%
7	9	< 0.1%
6	8	< 0.1%
5	32	< 0.1%
4	117	0.1%
3	577	0.4%
2	3694	2.4%
1	42117	27.6%

Target
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	112602
1	39932

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	152534
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Most occurring characters

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	152534	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	152534	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	152534	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	112602	73.8%
1	39932	26.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Requester_ID	Month	Volume_7days	Volume_15days	Volume_Monthly	ReclameAqui	SocialMedia	Tempo_Medio_Chat	Tempo_Medio_Email	AWT_Chat	%NFCR	%Insatisfação(CSAT)	CSAT_Rated	Target
0	10005693	2021_01	1	1	1	no	no	0.00000	8795.666667	0.00	0.000000	0.0	0	0
1	10008091	2021_01	1	1	1	no	no	0.00000	2503.750000	0.00	0.000000	0.0	0	0
2	10014513	2021_01	1	1	1	no	no	0.00000	12367.208333	0.00	0.000000	0.0	0	0
3	10014883	2021_01	1	2	2	no	no	1301.67100	8811.291667	10.00	0.666667	0.0	0	1
4	10015142	2021_01	0	1	2	no	no	409.19800	13107.416667	45.00	0.500000	0.0	0	1
5	10016341	2021_01	4	5	5	no	no	1305.76275	7878.166667	20.25	1.000000	0.0	0	1
6	10016421	2021_01	0	0	2	no	yes	0.00000	5461.416667	0.00	0.500000	0.0	0	1
7	1001838	2021_01	0	0	2	no	yes	0.00000	5463.375000	0.00	0.500000	0.0	0	1
8	10020118	2021_01	2	2	2	no	yes	2929.08500	25524.250000	36.00	0.000000	0.5	2	1
9	10021733	2021_01	1	1	2	no	yes	0.00000	5051.041667	0.00	0.500000	0.0	0	1

Last rows

	Requester_ID	Month	Volume_7days	Volume_15days	Volume_Monthly	ReclameAqui	SocialMedia	Tempo_Medio_Chat	AWT_Chat	CSAT_Rated
152524	9989542	2021_05	0	0	2	no	no	1315.2725	10.5	2
152525	9994325	2021_05	0	0	1	no	no	1599.9830	708.0	1
152526	9994918	2021_05	1	1	1	no	no	1397.1930	1073.0	0
152527	9995203	2021_05	0	0	1	no	no	1233.6290	44.0	0
152528	9995886	2021_05	0	0	1	no	no	219.4720	4.0	0
152529	999677	2021_05	0	0	1	no	no	895.5150	7.0	0
152530	9996859	2021_05	0	0	1	no	no	221.7070	13.0	1
152531	9996979	2021_05	0	0	1	no	no	258.6050	20.0	1
152532	9997	2021_05	0	0	1	no	no	2068.5710	43.0	0
152533	9997515	2021_05	1	1	1	no	no	3276.5170	8.0	0

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows